{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": false
   },
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "1 and 2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 111,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>电商</th>\n",
       "      <th>7/27</th>\n",
       "      <th>8/3</th>\n",
       "      <th>2系统</th>\n",
       "      <th>19018000201</th>\n",
       "      <th>针织</th>\n",
       "      <th>针织.1</th>\n",
       "      <th>第一批</th>\n",
       "      <th>0111</th>\n",
       "      <th>FOB</th>\n",
       "      <th>...</th>\n",
       "      <th>00</th>\n",
       "      <th>0</th>\n",
       "      <th>159</th>\n",
       "      <th>159000</th>\n",
       "      <th>18S1S2</th>\n",
       "      <th>朱晓红</th>\n",
       "      <th>140</th>\n",
       "      <th>7</th>\n",
       "      <th>48</th>\n",
       "      <th>15</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>电商</td>\n",
       "      <td>7/27</td>\n",
       "      <td>8/3</td>\n",
       "      <td>2系统</td>\n",
       "      <td>19018000201</td>\n",
       "      <td>针织</td>\n",
       "      <td>针织</td>\n",
       "      <td>第一批</td>\n",
       "      <td>144</td>\n",
       "      <td>FOB</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>159</td>\n",
       "      <td>159000</td>\n",
       "      <td>18S1S2</td>\n",
       "      <td>朱晓红</td>\n",
       "      <td>140</td>\n",
       "      <td>7</td>\n",
       "      <td>48</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>电商</td>\n",
       "      <td>7/27</td>\n",
       "      <td>8/3</td>\n",
       "      <td>2系统</td>\n",
       "      <td>19018000204</td>\n",
       "      <td>针织</td>\n",
       "      <td>针织</td>\n",
       "      <td>第一批</td>\n",
       "      <td>134</td>\n",
       "      <td>FOB</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>99</td>\n",
       "      <td>99000</td>\n",
       "      <td>18S1S2</td>\n",
       "      <td>朱晓红</td>\n",
       "      <td>140</td>\n",
       "      <td>7</td>\n",
       "      <td>48</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>电商</td>\n",
       "      <td>7/27</td>\n",
       "      <td>8/3</td>\n",
       "      <td>2系统</td>\n",
       "      <td>19018010201</td>\n",
       "      <td>针织</td>\n",
       "      <td>针织</td>\n",
       "      <td>第三批</td>\n",
       "      <td>1100</td>\n",
       "      <td>FOB</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>99</td>\n",
       "      <td>105534</td>\n",
       "      <td>18S1S2</td>\n",
       "      <td>朱晓红</td>\n",
       "      <td>100</td>\n",
       "      <td>11</td>\n",
       "      <td>50</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>电商</td>\n",
       "      <td>7/27</td>\n",
       "      <td>8/3</td>\n",
       "      <td>2系统</td>\n",
       "      <td>19018010201</td>\n",
       "      <td>针织</td>\n",
       "      <td>针织</td>\n",
       "      <td>第三批</td>\n",
       "      <td>3410</td>\n",
       "      <td>FOB</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>99</td>\n",
       "      <td>37323</td>\n",
       "      <td>18S1S2</td>\n",
       "      <td>朱晓红</td>\n",
       "      <td>100</td>\n",
       "      <td>4</td>\n",
       "      <td>50</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>电商</td>\n",
       "      <td>7/27</td>\n",
       "      <td>8/3</td>\n",
       "      <td>2系统</td>\n",
       "      <td>19018010201</td>\n",
       "      <td>针织</td>\n",
       "      <td>针织</td>\n",
       "      <td>第三批</td>\n",
       "      <td>8000</td>\n",
       "      <td>FOB</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>99</td>\n",
       "      <td>82467</td>\n",
       "      <td>18S1S2</td>\n",
       "      <td>朱晓红</td>\n",
       "      <td>100</td>\n",
       "      <td>8</td>\n",
       "      <td>50</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 32 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    电商  7/27  8/3  2系统  19018000201  针织 针织.1  第一批  0111  FOB ... 00  0  159  \\\n",
       "0                                                            ...              \n",
       "1   电商  7/27  8/3  2系统  19018000201  针织   针织  第一批   144  FOB ...  0  0  159   \n",
       "2   电商  7/27  8/3  2系统  19018000204  针织   针织  第一批   134  FOB ...  0  0   99   \n",
       "39  电商  7/27  8/3  2系统  19018010201  针织   针织  第三批  1100  FOB ...  1  0   99   \n",
       "40  电商  7/27  8/3  2系统  19018010201  针织   针织  第三批  3410  FOB ...  1  0   99   \n",
       "41  电商  7/27  8/3  2系统  19018010201  针织   针织  第三批  8000  FOB ...  1  0   99   \n",
       "\n",
       "    159000  18S1S2  朱晓红  140   7  48  15  \n",
       "0                                         \n",
       "1   159000  18S1S2  朱晓红  140   7  48  15  \n",
       "2    99000  18S1S2  朱晓红  140   7  48  15  \n",
       "39  105534  18S1S2  朱晓红  100  11  50  16  \n",
       "40   37323  18S1S2  朱晓红  100   4  50  16  \n",
       "41   82467  18S1S2  朱晓红  100   8  50  16  \n",
       "\n",
       "[5 rows x 32 columns]"
      ]
     },
     "execution_count": 111,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_excel(r'f:\\质检表.xls', sheetname='Sheet2', skiprows=1, index_col=0)\n",
    "import xlrd\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 115,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['﻿订单类别', '订单日期', 'NB5日期', '系统', '款号', '采购组', '采购组2', '批次', '色号', '模式',\n",
       "       '工厂', '订单量', '仓库', '波次', '货期', '离厂/到仓', '上市时间', '采购订单号', '跟单',\n",
       "       '地址（核对上市期）', '备注', '阿米巴', '中类', '性别', '吊牌价', '市值', '季节', '计划员', '件数/箱',\n",
       "       '箱数', '出货周数', '12'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 115,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "asd =xlrd.book.open_workbook_xls(r'f:\\质检表.xls')\n",
    "# xlrd.path.basename(r'f:\\质检表.xls')\n",
    "table = asd.sheets()[1]\n",
    "# column = list[table.row_values(0)][1:]\n",
    "# column\n",
    "\n",
    "index0 = df.columns\n",
    "column = table.row_values(0)\n",
    "index0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 113,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>﻿订单类别</th>\n",
       "      <th>订单日期</th>\n",
       "      <th>NB5日期</th>\n",
       "      <th>系统</th>\n",
       "      <th>款号</th>\n",
       "      <th>采购组</th>\n",
       "      <th>采购组2</th>\n",
       "      <th>批次</th>\n",
       "      <th>色号</th>\n",
       "      <th>模式</th>\n",
       "      <th>...</th>\n",
       "      <th>中类</th>\n",
       "      <th>性别</th>\n",
       "      <th>吊牌价</th>\n",
       "      <th>市值</th>\n",
       "      <th>季节</th>\n",
       "      <th>计划员</th>\n",
       "      <th>件数/箱</th>\n",
       "      <th>箱数</th>\n",
       "      <th>出货周数</th>\n",
       "      <th>12</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>电商</td>\n",
       "      <td>7/27</td>\n",
       "      <td>8/3</td>\n",
       "      <td>2系统</td>\n",
       "      <td>19018000201</td>\n",
       "      <td>针织</td>\n",
       "      <td>针织</td>\n",
       "      <td>第一批</td>\n",
       "      <td>144</td>\n",
       "      <td>FOB</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>159</td>\n",
       "      <td>159000</td>\n",
       "      <td>18S1S2</td>\n",
       "      <td>朱晓红</td>\n",
       "      <td>140</td>\n",
       "      <td>7</td>\n",
       "      <td>48</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>电商</td>\n",
       "      <td>7/27</td>\n",
       "      <td>8/3</td>\n",
       "      <td>2系统</td>\n",
       "      <td>19018000204</td>\n",
       "      <td>针织</td>\n",
       "      <td>针织</td>\n",
       "      <td>第一批</td>\n",
       "      <td>134</td>\n",
       "      <td>FOB</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>99</td>\n",
       "      <td>99000</td>\n",
       "      <td>18S1S2</td>\n",
       "      <td>朱晓红</td>\n",
       "      <td>140</td>\n",
       "      <td>7</td>\n",
       "      <td>48</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>电商</td>\n",
       "      <td>7/27</td>\n",
       "      <td>8/3</td>\n",
       "      <td>2系统</td>\n",
       "      <td>19018010201</td>\n",
       "      <td>针织</td>\n",
       "      <td>针织</td>\n",
       "      <td>第三批</td>\n",
       "      <td>1100</td>\n",
       "      <td>FOB</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>99</td>\n",
       "      <td>105534</td>\n",
       "      <td>18S1S2</td>\n",
       "      <td>朱晓红</td>\n",
       "      <td>100</td>\n",
       "      <td>11</td>\n",
       "      <td>50</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>电商</td>\n",
       "      <td>7/27</td>\n",
       "      <td>8/3</td>\n",
       "      <td>2系统</td>\n",
       "      <td>19018010201</td>\n",
       "      <td>针织</td>\n",
       "      <td>针织</td>\n",
       "      <td>第三批</td>\n",
       "      <td>3410</td>\n",
       "      <td>FOB</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>99</td>\n",
       "      <td>37323</td>\n",
       "      <td>18S1S2</td>\n",
       "      <td>朱晓红</td>\n",
       "      <td>100</td>\n",
       "      <td>4</td>\n",
       "      <td>50</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>电商</td>\n",
       "      <td>7/27</td>\n",
       "      <td>8/3</td>\n",
       "      <td>2系统</td>\n",
       "      <td>19018010201</td>\n",
       "      <td>针织</td>\n",
       "      <td>针织</td>\n",
       "      <td>第三批</td>\n",
       "      <td>8000</td>\n",
       "      <td>FOB</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>99</td>\n",
       "      <td>82467</td>\n",
       "      <td>18S1S2</td>\n",
       "      <td>朱晓红</td>\n",
       "      <td>100</td>\n",
       "      <td>8</td>\n",
       "      <td>50</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>电商</td>\n",
       "      <td>7/27</td>\n",
       "      <td>8/3</td>\n",
       "      <td>2系统</td>\n",
       "      <td>19018010201</td>\n",
       "      <td>针织</td>\n",
       "      <td>针织</td>\n",
       "      <td>第三批</td>\n",
       "      <td>1100</td>\n",
       "      <td>FOB</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>99</td>\n",
       "      <td>113454</td>\n",
       "      <td>18S1S2</td>\n",
       "      <td>朱晓红</td>\n",
       "      <td>100</td>\n",
       "      <td>11</td>\n",
       "      <td>50</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>电商</td>\n",
       "      <td>7/27</td>\n",
       "      <td>8/3</td>\n",
       "      <td>2系统</td>\n",
       "      <td>19018010201</td>\n",
       "      <td>针织</td>\n",
       "      <td>针织</td>\n",
       "      <td>第三批</td>\n",
       "      <td>3410</td>\n",
       "      <td>FOB</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>99</td>\n",
       "      <td>33561</td>\n",
       "      <td>18S1S2</td>\n",
       "      <td>朱晓红</td>\n",
       "      <td>100</td>\n",
       "      <td>3</td>\n",
       "      <td>50</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>电商</td>\n",
       "      <td>7/27</td>\n",
       "      <td>8/3</td>\n",
       "      <td>2系统</td>\n",
       "      <td>19018010201</td>\n",
       "      <td>针织</td>\n",
       "      <td>针织</td>\n",
       "      <td>第三批</td>\n",
       "      <td>8000</td>\n",
       "      <td>FOB</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>99</td>\n",
       "      <td>76527</td>\n",
       "      <td>18S1S2</td>\n",
       "      <td>朱晓红</td>\n",
       "      <td>100</td>\n",
       "      <td>8</td>\n",
       "      <td>50</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>电商</td>\n",
       "      <td>7/27</td>\n",
       "      <td>8/3</td>\n",
       "      <td>2系统</td>\n",
       "      <td>19018010201</td>\n",
       "      <td>针织</td>\n",
       "      <td>针织</td>\n",
       "      <td>第三批</td>\n",
       "      <td>1100</td>\n",
       "      <td>FOB</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>99</td>\n",
       "      <td>454212</td>\n",
       "      <td>18S1S2</td>\n",
       "      <td>朱晓红</td>\n",
       "      <td>100</td>\n",
       "      <td>46</td>\n",
       "      <td>50</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>电商</td>\n",
       "      <td>7/27</td>\n",
       "      <td>8/3</td>\n",
       "      <td>2系统</td>\n",
       "      <td>19018010201</td>\n",
       "      <td>针织</td>\n",
       "      <td>针织</td>\n",
       "      <td>第三批</td>\n",
       "      <td>3410</td>\n",
       "      <td>FOB</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>99</td>\n",
       "      <td>146916</td>\n",
       "      <td>18S1S2</td>\n",
       "      <td>朱晓红</td>\n",
       "      <td>100</td>\n",
       "      <td>15</td>\n",
       "      <td>50</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>电商</td>\n",
       "      <td>7/27</td>\n",
       "      <td>8/3</td>\n",
       "      <td>2系统</td>\n",
       "      <td>19018010201</td>\n",
       "      <td>针织</td>\n",
       "      <td>针织</td>\n",
       "      <td>第三批</td>\n",
       "      <td>8000</td>\n",
       "      <td>FOB</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>99</td>\n",
       "      <td>306306</td>\n",
       "      <td>18S1S2</td>\n",
       "      <td>朱晓红</td>\n",
       "      <td>100</td>\n",
       "      <td>31</td>\n",
       "      <td>50</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>电商</td>\n",
       "      <td>7/27</td>\n",
       "      <td>8/3</td>\n",
       "      <td>2系统</td>\n",
       "      <td>19018010202</td>\n",
       "      <td>针织</td>\n",
       "      <td>针织</td>\n",
       "      <td>第三批</td>\n",
       "      <td>1100</td>\n",
       "      <td>FOB</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>89</td>\n",
       "      <td>90246</td>\n",
       "      <td>18S1S2</td>\n",
       "      <td>朱晓红</td>\n",
       "      <td>100</td>\n",
       "      <td>10</td>\n",
       "      <td>50</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>电商</td>\n",
       "      <td>7/27</td>\n",
       "      <td>8/3</td>\n",
       "      <td>2系统</td>\n",
       "      <td>19018010202</td>\n",
       "      <td>针织</td>\n",
       "      <td>针织</td>\n",
       "      <td>第三批</td>\n",
       "      <td>8000</td>\n",
       "      <td>FOB</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>89</td>\n",
       "      <td>95586</td>\n",
       "      <td>18S1S2</td>\n",
       "      <td>朱晓红</td>\n",
       "      <td>100</td>\n",
       "      <td>11</td>\n",
       "      <td>50</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>电商</td>\n",
       "      <td>7/27</td>\n",
       "      <td>8/3</td>\n",
       "      <td>2系统</td>\n",
       "      <td>19018010202</td>\n",
       "      <td>针织</td>\n",
       "      <td>针织</td>\n",
       "      <td>第三批</td>\n",
       "      <td>9000</td>\n",
       "      <td>FOB</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>89</td>\n",
       "      <td>74137</td>\n",
       "      <td>18S1S2</td>\n",
       "      <td>朱晓红</td>\n",
       "      <td>100</td>\n",
       "      <td>8</td>\n",
       "      <td>50</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>电商</td>\n",
       "      <td>7/27</td>\n",
       "      <td>8/3</td>\n",
       "      <td>2系统</td>\n",
       "      <td>19018010202</td>\n",
       "      <td>针织</td>\n",
       "      <td>针织</td>\n",
       "      <td>第三批</td>\n",
       "      <td>1100</td>\n",
       "      <td>FOB</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>89</td>\n",
       "      <td>92293</td>\n",
       "      <td>18S1S2</td>\n",
       "      <td>朱晓红</td>\n",
       "      <td>100</td>\n",
       "      <td>10</td>\n",
       "      <td>50</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>电商</td>\n",
       "      <td>7/27</td>\n",
       "      <td>8/3</td>\n",
       "      <td>2系统</td>\n",
       "      <td>19018010202</td>\n",
       "      <td>针织</td>\n",
       "      <td>针织</td>\n",
       "      <td>第三批</td>\n",
       "      <td>8000</td>\n",
       "      <td>FOB</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>89</td>\n",
       "      <td>103685</td>\n",
       "      <td>18S1S2</td>\n",
       "      <td>朱晓红</td>\n",
       "      <td>100</td>\n",
       "      <td>12</td>\n",
       "      <td>50</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>电商</td>\n",
       "      <td>7/27</td>\n",
       "      <td>8/3</td>\n",
       "      <td>2系统</td>\n",
       "      <td>19018010202</td>\n",
       "      <td>针织</td>\n",
       "      <td>针织</td>\n",
       "      <td>第三批</td>\n",
       "      <td>9000</td>\n",
       "      <td>FOB</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>89</td>\n",
       "      <td>84817</td>\n",
       "      <td>18S1S2</td>\n",
       "      <td>朱晓红</td>\n",
       "      <td>100</td>\n",
       "      <td>10</td>\n",
       "      <td>50</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>电商</td>\n",
       "      <td>7/27</td>\n",
       "      <td>8/3</td>\n",
       "      <td>2系统</td>\n",
       "      <td>19018010202</td>\n",
       "      <td>针织</td>\n",
       "      <td>针织</td>\n",
       "      <td>第三批</td>\n",
       "      <td>1100</td>\n",
       "      <td>FOB</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>89</td>\n",
       "      <td>369261</td>\n",
       "      <td>18S1S2</td>\n",
       "      <td>朱晓红</td>\n",
       "      <td>100</td>\n",
       "      <td>41</td>\n",
       "      <td>50</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>电商</td>\n",
       "      <td>7/27</td>\n",
       "      <td>8/3</td>\n",
       "      <td>2系统</td>\n",
       "      <td>19018010202</td>\n",
       "      <td>针织</td>\n",
       "      <td>针织</td>\n",
       "      <td>第三批</td>\n",
       "      <td>8000</td>\n",
       "      <td>FOB</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>89</td>\n",
       "      <td>414829</td>\n",
       "      <td>18S1S2</td>\n",
       "      <td>朱晓红</td>\n",
       "      <td>100</td>\n",
       "      <td>47</td>\n",
       "      <td>50</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>电商</td>\n",
       "      <td>7/27</td>\n",
       "      <td>8/3</td>\n",
       "      <td>2系统</td>\n",
       "      <td>19018010202</td>\n",
       "      <td>针织</td>\n",
       "      <td>针织</td>\n",
       "      <td>第三批</td>\n",
       "      <td>9000</td>\n",
       "      <td>FOB</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>89</td>\n",
       "      <td>339446</td>\n",
       "      <td>18S1S2</td>\n",
       "      <td>朱晓红</td>\n",
       "      <td>100</td>\n",
       "      <td>38</td>\n",
       "      <td>50</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>电商</td>\n",
       "      <td>7/27</td>\n",
       "      <td>8/3</td>\n",
       "      <td>2系统</td>\n",
       "      <td>19018010203</td>\n",
       "      <td>针织</td>\n",
       "      <td>针织</td>\n",
       "      <td>第二批</td>\n",
       "      <td>1100</td>\n",
       "      <td>FOB</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>119</td>\n",
       "      <td>153867</td>\n",
       "      <td>18S1S2</td>\n",
       "      <td>朱晓红</td>\n",
       "      <td>100</td>\n",
       "      <td>13</td>\n",
       "      <td>49</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>电商</td>\n",
       "      <td>7/27</td>\n",
       "      <td>8/3</td>\n",
       "      <td>2系统</td>\n",
       "      <td>19018010203</td>\n",
       "      <td>针织</td>\n",
       "      <td>针织</td>\n",
       "      <td>第二批</td>\n",
       "      <td>6600</td>\n",
       "      <td>FOB</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>119</td>\n",
       "      <td>118643</td>\n",
       "      <td>18S1S2</td>\n",
       "      <td>朱晓红</td>\n",
       "      <td>100</td>\n",
       "      <td>10</td>\n",
       "      <td>49</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>电商</td>\n",
       "      <td>7/27</td>\n",
       "      <td>8/3</td>\n",
       "      <td>2系统</td>\n",
       "      <td>19018010203</td>\n",
       "      <td>针织</td>\n",
       "      <td>针织</td>\n",
       "      <td>第二批</td>\n",
       "      <td>9000</td>\n",
       "      <td>FOB</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>119</td>\n",
       "      <td>153867</td>\n",
       "      <td>18S1S2</td>\n",
       "      <td>朱晓红</td>\n",
       "      <td>100</td>\n",
       "      <td>13</td>\n",
       "      <td>49</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>电商</td>\n",
       "      <td>7/27</td>\n",
       "      <td>8/3</td>\n",
       "      <td>2系统</td>\n",
       "      <td>19018010203</td>\n",
       "      <td>针织</td>\n",
       "      <td>针织</td>\n",
       "      <td>第二批</td>\n",
       "      <td>1100</td>\n",
       "      <td>FOB</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>119</td>\n",
       "      <td>209440</td>\n",
       "      <td>18S1S2</td>\n",
       "      <td>朱晓红</td>\n",
       "      <td>100</td>\n",
       "      <td>18</td>\n",
       "      <td>51</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>电商</td>\n",
       "      <td>7/27</td>\n",
       "      <td>8/3</td>\n",
       "      <td>2系统</td>\n",
       "      <td>19018010203</td>\n",
       "      <td>针织</td>\n",
       "      <td>针织</td>\n",
       "      <td>第二批</td>\n",
       "      <td>6600</td>\n",
       "      <td>FOB</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>119</td>\n",
       "      <td>121499</td>\n",
       "      <td>18S1S2</td>\n",
       "      <td>朱晓红</td>\n",
       "      <td>100</td>\n",
       "      <td>10</td>\n",
       "      <td>51</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>电商</td>\n",
       "      <td>7/27</td>\n",
       "      <td>8/3</td>\n",
       "      <td>2系统</td>\n",
       "      <td>19018010203</td>\n",
       "      <td>针织</td>\n",
       "      <td>针织</td>\n",
       "      <td>第二批</td>\n",
       "      <td>9000</td>\n",
       "      <td>FOB</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>119</td>\n",
       "      <td>173740</td>\n",
       "      <td>18S1S2</td>\n",
       "      <td>朱晓红</td>\n",
       "      <td>100</td>\n",
       "      <td>15</td>\n",
       "      <td>51</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>电商</td>\n",
       "      <td>7/27</td>\n",
       "      <td>8/3</td>\n",
       "      <td>2系统</td>\n",
       "      <td>19018010203</td>\n",
       "      <td>针织</td>\n",
       "      <td>针织</td>\n",
       "      <td>第二批</td>\n",
       "      <td>1100</td>\n",
       "      <td>FOB</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>119</td>\n",
       "      <td>447202</td>\n",
       "      <td>18S1S2</td>\n",
       "      <td>朱晓红</td>\n",
       "      <td>100</td>\n",
       "      <td>38</td>\n",
       "      <td>49</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>电商</td>\n",
       "      <td>7/27</td>\n",
       "      <td>8/3</td>\n",
       "      <td>2系统</td>\n",
       "      <td>19018010203</td>\n",
       "      <td>针织</td>\n",
       "      <td>针织</td>\n",
       "      <td>第二批</td>\n",
       "      <td>6600</td>\n",
       "      <td>FOB</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>119</td>\n",
       "      <td>244426</td>\n",
       "      <td>18S1S2</td>\n",
       "      <td>朱晓红</td>\n",
       "      <td>100</td>\n",
       "      <td>21</td>\n",
       "      <td>49</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>电商</td>\n",
       "      <td>7/27</td>\n",
       "      <td>8/3</td>\n",
       "      <td>2系统</td>\n",
       "      <td>19018010203</td>\n",
       "      <td>针织</td>\n",
       "      <td>针织</td>\n",
       "      <td>第二批</td>\n",
       "      <td>9000</td>\n",
       "      <td>FOB</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>119</td>\n",
       "      <td>357833</td>\n",
       "      <td>18S1S2</td>\n",
       "      <td>朱晓红</td>\n",
       "      <td>100</td>\n",
       "      <td>30</td>\n",
       "      <td>49</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>电商</td>\n",
       "      <td>7/27</td>\n",
       "      <td>8/3</td>\n",
       "      <td>2系统</td>\n",
       "      <td>19018010203</td>\n",
       "      <td>针织</td>\n",
       "      <td>针织</td>\n",
       "      <td>第二批</td>\n",
       "      <td>1100</td>\n",
       "      <td>FOB</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>119</td>\n",
       "      <td>391391</td>\n",
       "      <td>18S1S2</td>\n",
       "      <td>朱晓红</td>\n",
       "      <td>100</td>\n",
       "      <td>33</td>\n",
       "      <td>51</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2653</th>\n",
       "      <td>订货会</td>\n",
       "      <td>8/15</td>\n",
       "      <td>8/15</td>\n",
       "      <td>2系统</td>\n",
       "      <td>12028001017</td>\n",
       "      <td>针织</td>\n",
       "      <td>针织</td>\n",
       "      <td>初夏</td>\n",
       "      <td>291</td>\n",
       "      <td>FOB</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>99</td>\n",
       "      <td>48510</td>\n",
       "      <td>18S1S2</td>\n",
       "      <td>朱晓红</td>\n",
       "      <td>140</td>\n",
       "      <td>308</td>\n",
       "      <td>50</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2658</th>\n",
       "      <td>订货会</td>\n",
       "      <td>8/15</td>\n",
       "      <td>8/15</td>\n",
       "      <td>2系统</td>\n",
       "      <td>12028001020</td>\n",
       "      <td>针织</td>\n",
       "      <td>针织</td>\n",
       "      <td>初夏</td>\n",
       "      <td>1000</td>\n",
       "      <td>ODM</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>119</td>\n",
       "      <td>53074</td>\n",
       "      <td>18S1S2</td>\n",
       "      <td>朱晓红</td>\n",
       "      <td>140</td>\n",
       "      <td>308</td>\n",
       "      <td>50</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2659</th>\n",
       "      <td>订货会</td>\n",
       "      <td>8/15</td>\n",
       "      <td>8/15</td>\n",
       "      <td>2系统</td>\n",
       "      <td>12028001020</td>\n",
       "      <td>针织</td>\n",
       "      <td>针织</td>\n",
       "      <td>初夏</td>\n",
       "      <td>1000</td>\n",
       "      <td>ODM</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>119</td>\n",
       "      <td>82110</td>\n",
       "      <td>18S1S2</td>\n",
       "      <td>朱晓红</td>\n",
       "      <td>140</td>\n",
       "      <td>308</td>\n",
       "      <td>50</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2660</th>\n",
       "      <td>订货会</td>\n",
       "      <td>8/15</td>\n",
       "      <td>8/15</td>\n",
       "      <td>2系统</td>\n",
       "      <td>12028001020</td>\n",
       "      <td>针织</td>\n",
       "      <td>针织</td>\n",
       "      <td>初夏</td>\n",
       "      <td>9000</td>\n",
       "      <td>ODM</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>119</td>\n",
       "      <td>51527</td>\n",
       "      <td>18S1S2</td>\n",
       "      <td>朱晓红</td>\n",
       "      <td>140</td>\n",
       "      <td>308</td>\n",
       "      <td>50</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2661</th>\n",
       "      <td>订货会</td>\n",
       "      <td>8/15</td>\n",
       "      <td>8/15</td>\n",
       "      <td>2系统</td>\n",
       "      <td>12028001020</td>\n",
       "      <td>针织</td>\n",
       "      <td>针织</td>\n",
       "      <td>初夏</td>\n",
       "      <td>9000</td>\n",
       "      <td>ODM</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>119</td>\n",
       "      <td>55216</td>\n",
       "      <td>18S1S2</td>\n",
       "      <td>朱晓红</td>\n",
       "      <td>140</td>\n",
       "      <td>308</td>\n",
       "      <td>50</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2790</th>\n",
       "      <td>订货会</td>\n",
       "      <td>8/15</td>\n",
       "      <td>8/15</td>\n",
       "      <td>1系统</td>\n",
       "      <td>12028160020</td>\n",
       "      <td>针织</td>\n",
       "      <td>针织</td>\n",
       "      <td>初夏</td>\n",
       "      <td>6129</td>\n",
       "      <td>FOB</td>\n",
       "      <td>...</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>159</td>\n",
       "      <td>105258</td>\n",
       "      <td>18S1S2</td>\n",
       "      <td>朱晓红</td>\n",
       "      <td>40</td>\n",
       "      <td>1077</td>\n",
       "      <td>50</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2791</th>\n",
       "      <td>订货会</td>\n",
       "      <td>8/15</td>\n",
       "      <td>8/15</td>\n",
       "      <td>1系统</td>\n",
       "      <td>12028160020</td>\n",
       "      <td>针织</td>\n",
       "      <td>针织</td>\n",
       "      <td>初夏</td>\n",
       "      <td>6129</td>\n",
       "      <td>FOB</td>\n",
       "      <td>...</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>159</td>\n",
       "      <td>90948</td>\n",
       "      <td>18S1S2</td>\n",
       "      <td>朱晓红</td>\n",
       "      <td>40</td>\n",
       "      <td>1077</td>\n",
       "      <td>50</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2792</th>\n",
       "      <td>订货会</td>\n",
       "      <td>8/15</td>\n",
       "      <td>8/15</td>\n",
       "      <td>1系统</td>\n",
       "      <td>12028160020</td>\n",
       "      <td>针织</td>\n",
       "      <td>针织</td>\n",
       "      <td>初夏</td>\n",
       "      <td>8640</td>\n",
       "      <td>FOB</td>\n",
       "      <td>...</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>159</td>\n",
       "      <td>92061</td>\n",
       "      <td>18S1S2</td>\n",
       "      <td>朱晓红</td>\n",
       "      <td>40</td>\n",
       "      <td>1077</td>\n",
       "      <td>50</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2793</th>\n",
       "      <td>订货会</td>\n",
       "      <td>8/15</td>\n",
       "      <td>8/15</td>\n",
       "      <td>1系统</td>\n",
       "      <td>12028160020</td>\n",
       "      <td>针织</td>\n",
       "      <td>针织</td>\n",
       "      <td>初夏</td>\n",
       "      <td>8640</td>\n",
       "      <td>FOB</td>\n",
       "      <td>...</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>159</td>\n",
       "      <td>65349</td>\n",
       "      <td>18S1S2</td>\n",
       "      <td>朱晓红</td>\n",
       "      <td>40</td>\n",
       "      <td>1077</td>\n",
       "      <td>50</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2794</th>\n",
       "      <td>订货会</td>\n",
       "      <td>8/15</td>\n",
       "      <td>8/15</td>\n",
       "      <td>2系统</td>\n",
       "      <td>12028160022</td>\n",
       "      <td>针织</td>\n",
       "      <td>针织</td>\n",
       "      <td>初夏</td>\n",
       "      <td>1100</td>\n",
       "      <td>CFOB</td>\n",
       "      <td>...</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>119</td>\n",
       "      <td>408170</td>\n",
       "      <td>18S1S2</td>\n",
       "      <td>朱晓红</td>\n",
       "      <td>40</td>\n",
       "      <td>1077</td>\n",
       "      <td>51</td>\n",
       "      <td>32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2795</th>\n",
       "      <td>订货会</td>\n",
       "      <td>8/15</td>\n",
       "      <td>8/15</td>\n",
       "      <td>2系统</td>\n",
       "      <td>12028160022</td>\n",
       "      <td>针织</td>\n",
       "      <td>针织</td>\n",
       "      <td>初夏</td>\n",
       "      <td>1100</td>\n",
       "      <td>CFOB</td>\n",
       "      <td>...</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>119</td>\n",
       "      <td>661045</td>\n",
       "      <td>18S1S2</td>\n",
       "      <td>朱晓红</td>\n",
       "      <td>40</td>\n",
       "      <td>1077</td>\n",
       "      <td>52</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2796</th>\n",
       "      <td>订货会</td>\n",
       "      <td>8/15</td>\n",
       "      <td>8/15</td>\n",
       "      <td>2系统</td>\n",
       "      <td>12028160022</td>\n",
       "      <td>针织</td>\n",
       "      <td>针织</td>\n",
       "      <td>初夏</td>\n",
       "      <td>1100</td>\n",
       "      <td>CFOB</td>\n",
       "      <td>...</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>119</td>\n",
       "      <td>333200</td>\n",
       "      <td>18S1S2</td>\n",
       "      <td>朱晓红</td>\n",
       "      <td>40</td>\n",
       "      <td>1077</td>\n",
       "      <td>50</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2797</th>\n",
       "      <td>订货会</td>\n",
       "      <td>8/15</td>\n",
       "      <td>8/15</td>\n",
       "      <td>2系统</td>\n",
       "      <td>12028160022</td>\n",
       "      <td>针织</td>\n",
       "      <td>针织</td>\n",
       "      <td>初夏</td>\n",
       "      <td>6606</td>\n",
       "      <td>CFOB</td>\n",
       "      <td>...</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>119</td>\n",
       "      <td>427091</td>\n",
       "      <td>18S1S2</td>\n",
       "      <td>朱晓红</td>\n",
       "      <td>40</td>\n",
       "      <td>1077</td>\n",
       "      <td>51</td>\n",
       "      <td>32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2798</th>\n",
       "      <td>订货会</td>\n",
       "      <td>8/15</td>\n",
       "      <td>8/15</td>\n",
       "      <td>2系统</td>\n",
       "      <td>12028160022</td>\n",
       "      <td>针织</td>\n",
       "      <td>针织</td>\n",
       "      <td>初夏</td>\n",
       "      <td>6606</td>\n",
       "      <td>CFOB</td>\n",
       "      <td>...</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>119</td>\n",
       "      <td>685916</td>\n",
       "      <td>18S1S2</td>\n",
       "      <td>朱晓红</td>\n",
       "      <td>40</td>\n",
       "      <td>1077</td>\n",
       "      <td>52</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2799</th>\n",
       "      <td>订货会</td>\n",
       "      <td>8/15</td>\n",
       "      <td>8/15</td>\n",
       "      <td>2系统</td>\n",
       "      <td>12028160022</td>\n",
       "      <td>针织</td>\n",
       "      <td>针织</td>\n",
       "      <td>初夏</td>\n",
       "      <td>6606</td>\n",
       "      <td>CFOB</td>\n",
       "      <td>...</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>119</td>\n",
       "      <td>364140</td>\n",
       "      <td>18S1S2</td>\n",
       "      <td>朱晓红</td>\n",
       "      <td>40</td>\n",
       "      <td>1077</td>\n",
       "      <td>50</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2800</th>\n",
       "      <td>订货会</td>\n",
       "      <td>8/15</td>\n",
       "      <td>8/15</td>\n",
       "      <td>2系统</td>\n",
       "      <td>12028160022</td>\n",
       "      <td>针织</td>\n",
       "      <td>针织</td>\n",
       "      <td>初夏</td>\n",
       "      <td>8640</td>\n",
       "      <td>CFOB</td>\n",
       "      <td>...</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>119</td>\n",
       "      <td>20468</td>\n",
       "      <td>18S1S2</td>\n",
       "      <td>朱晓红</td>\n",
       "      <td>40</td>\n",
       "      <td>1077</td>\n",
       "      <td>51</td>\n",
       "      <td>32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2801</th>\n",
       "      <td>订货会</td>\n",
       "      <td>8/15</td>\n",
       "      <td>8/15</td>\n",
       "      <td>2系统</td>\n",
       "      <td>12028160022</td>\n",
       "      <td>针织</td>\n",
       "      <td>针织</td>\n",
       "      <td>初夏</td>\n",
       "      <td>8640</td>\n",
       "      <td>CFOB</td>\n",
       "      <td>...</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>119</td>\n",
       "      <td>54026</td>\n",
       "      <td>18S1S2</td>\n",
       "      <td>朱晓红</td>\n",
       "      <td>40</td>\n",
       "      <td>1077</td>\n",
       "      <td>52</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2802</th>\n",
       "      <td>订货会</td>\n",
       "      <td>8/15</td>\n",
       "      <td>8/15</td>\n",
       "      <td>2系统</td>\n",
       "      <td>12028160022</td>\n",
       "      <td>针织</td>\n",
       "      <td>针织</td>\n",
       "      <td>初夏</td>\n",
       "      <td>8640</td>\n",
       "      <td>CFOB</td>\n",
       "      <td>...</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>119</td>\n",
       "      <td>20706</td>\n",
       "      <td>18S1S2</td>\n",
       "      <td>朱晓红</td>\n",
       "      <td>40</td>\n",
       "      <td>1077</td>\n",
       "      <td>50</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2819</th>\n",
       "      <td>订货会</td>\n",
       "      <td>8/15</td>\n",
       "      <td>8/15</td>\n",
       "      <td>2系统</td>\n",
       "      <td>12028161009</td>\n",
       "      <td>针织</td>\n",
       "      <td>针织</td>\n",
       "      <td>初夏</td>\n",
       "      <td>1100</td>\n",
       "      <td>ODM</td>\n",
       "      <td>...</td>\n",
       "      <td>16</td>\n",
       "      <td>1</td>\n",
       "      <td>139</td>\n",
       "      <td>211836</td>\n",
       "      <td>18S1S2</td>\n",
       "      <td>朱晓红</td>\n",
       "      <td>40</td>\n",
       "      <td>1077</td>\n",
       "      <td>50</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2820</th>\n",
       "      <td>订货会</td>\n",
       "      <td>8/15</td>\n",
       "      <td>8/15</td>\n",
       "      <td>2系统</td>\n",
       "      <td>12028161009</td>\n",
       "      <td>针织</td>\n",
       "      <td>针织</td>\n",
       "      <td>初夏</td>\n",
       "      <td>1100</td>\n",
       "      <td>ODM</td>\n",
       "      <td>...</td>\n",
       "      <td>16</td>\n",
       "      <td>1</td>\n",
       "      <td>139</td>\n",
       "      <td>14595</td>\n",
       "      <td>18S1S2</td>\n",
       "      <td>朱晓红</td>\n",
       "      <td>40</td>\n",
       "      <td>1077</td>\n",
       "      <td>50</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2821</th>\n",
       "      <td>订货会</td>\n",
       "      <td>8/15</td>\n",
       "      <td>8/15</td>\n",
       "      <td>2系统</td>\n",
       "      <td>12028161009</td>\n",
       "      <td>针织</td>\n",
       "      <td>针织</td>\n",
       "      <td>初夏</td>\n",
       "      <td>4500</td>\n",
       "      <td>ODM</td>\n",
       "      <td>...</td>\n",
       "      <td>16</td>\n",
       "      <td>1</td>\n",
       "      <td>139</td>\n",
       "      <td>173611</td>\n",
       "      <td>18S1S2</td>\n",
       "      <td>朱晓红</td>\n",
       "      <td>40</td>\n",
       "      <td>1077</td>\n",
       "      <td>50</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2822</th>\n",
       "      <td>订货会</td>\n",
       "      <td>8/15</td>\n",
       "      <td>8/15</td>\n",
       "      <td>2系统</td>\n",
       "      <td>12028161009</td>\n",
       "      <td>针织</td>\n",
       "      <td>针织</td>\n",
       "      <td>初夏</td>\n",
       "      <td>4500</td>\n",
       "      <td>ODM</td>\n",
       "      <td>...</td>\n",
       "      <td>16</td>\n",
       "      <td>1</td>\n",
       "      <td>139</td>\n",
       "      <td>15707</td>\n",
       "      <td>18S1S2</td>\n",
       "      <td>朱晓红</td>\n",
       "      <td>40</td>\n",
       "      <td>1077</td>\n",
       "      <td>50</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2823</th>\n",
       "      <td>订货会</td>\n",
       "      <td>8/15</td>\n",
       "      <td>8/15</td>\n",
       "      <td>2系统</td>\n",
       "      <td>12028161009</td>\n",
       "      <td>针织</td>\n",
       "      <td>针织</td>\n",
       "      <td>初夏</td>\n",
       "      <td>9000</td>\n",
       "      <td>ODM</td>\n",
       "      <td>...</td>\n",
       "      <td>16</td>\n",
       "      <td>1</td>\n",
       "      <td>139</td>\n",
       "      <td>223234</td>\n",
       "      <td>18S1S2</td>\n",
       "      <td>朱晓红</td>\n",
       "      <td>40</td>\n",
       "      <td>1077</td>\n",
       "      <td>50</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2824</th>\n",
       "      <td>订货会</td>\n",
       "      <td>8/15</td>\n",
       "      <td>8/15</td>\n",
       "      <td>2系统</td>\n",
       "      <td>12028161009</td>\n",
       "      <td>针织</td>\n",
       "      <td>针织</td>\n",
       "      <td>初夏</td>\n",
       "      <td>9000</td>\n",
       "      <td>ODM</td>\n",
       "      <td>...</td>\n",
       "      <td>16</td>\n",
       "      <td>1</td>\n",
       "      <td>139</td>\n",
       "      <td>23630</td>\n",
       "      <td>18S1S2</td>\n",
       "      <td>朱晓红</td>\n",
       "      <td>40</td>\n",
       "      <td>1077</td>\n",
       "      <td>50</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2829</th>\n",
       "      <td>订货会</td>\n",
       "      <td>8/15</td>\n",
       "      <td>8/15</td>\n",
       "      <td>2系统</td>\n",
       "      <td>12028260264</td>\n",
       "      <td>针织</td>\n",
       "      <td>针织</td>\n",
       "      <td>初夏</td>\n",
       "      <td>9000</td>\n",
       "      <td>CFOB</td>\n",
       "      <td>...</td>\n",
       "      <td>26</td>\n",
       "      <td>0</td>\n",
       "      <td>199</td>\n",
       "      <td>193229</td>\n",
       "      <td>18S1S2</td>\n",
       "      <td>朱晓红</td>\n",
       "      <td>70</td>\n",
       "      <td>615</td>\n",
       "      <td>50</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2830</th>\n",
       "      <td>订货会</td>\n",
       "      <td>8/15</td>\n",
       "      <td>8/15</td>\n",
       "      <td>2系统</td>\n",
       "      <td>12028260264</td>\n",
       "      <td>针织</td>\n",
       "      <td>针织</td>\n",
       "      <td>初夏</td>\n",
       "      <td>9000</td>\n",
       "      <td>CFOB</td>\n",
       "      <td>...</td>\n",
       "      <td>26</td>\n",
       "      <td>0</td>\n",
       "      <td>199</td>\n",
       "      <td>53929</td>\n",
       "      <td>18S1S2</td>\n",
       "      <td>朱晓红</td>\n",
       "      <td>70</td>\n",
       "      <td>615</td>\n",
       "      <td>50</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4994</th>\n",
       "      <td>订货会</td>\n",
       "      <td>8/8</td>\n",
       "      <td>8/28</td>\n",
       "      <td>2系统</td>\n",
       "      <td>12018271301</td>\n",
       "      <td>针织</td>\n",
       "      <td>针织</td>\n",
       "      <td>春2</td>\n",
       "      <td>12</td>\n",
       "      <td>ODM</td>\n",
       "      <td>...</td>\n",
       "      <td>27</td>\n",
       "      <td>1</td>\n",
       "      <td>179</td>\n",
       "      <td>35621</td>\n",
       "      <td>18S1S2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>60</td>\n",
       "      <td>718</td>\n",
       "      <td>49</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4995</th>\n",
       "      <td>订货会</td>\n",
       "      <td>8/8</td>\n",
       "      <td>8/28</td>\n",
       "      <td>2系统</td>\n",
       "      <td>12018271301</td>\n",
       "      <td>针织</td>\n",
       "      <td>针织</td>\n",
       "      <td>春2</td>\n",
       "      <td>12</td>\n",
       "      <td>ODM</td>\n",
       "      <td>...</td>\n",
       "      <td>27</td>\n",
       "      <td>1</td>\n",
       "      <td>179</td>\n",
       "      <td>107579</td>\n",
       "      <td>18S1S2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>60</td>\n",
       "      <td>718</td>\n",
       "      <td>49</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4996</th>\n",
       "      <td>订货会</td>\n",
       "      <td>8/8</td>\n",
       "      <td>8/28</td>\n",
       "      <td>2系统</td>\n",
       "      <td>12018271301</td>\n",
       "      <td>针织</td>\n",
       "      <td>针织</td>\n",
       "      <td>春2</td>\n",
       "      <td>9000</td>\n",
       "      <td>ODM</td>\n",
       "      <td>...</td>\n",
       "      <td>27</td>\n",
       "      <td>1</td>\n",
       "      <td>179</td>\n",
       "      <td>249526</td>\n",
       "      <td>18S1S2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>60</td>\n",
       "      <td>718</td>\n",
       "      <td>49</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4997</th>\n",
       "      <td>订货会</td>\n",
       "      <td>8/8</td>\n",
       "      <td>8/28</td>\n",
       "      <td>2系统</td>\n",
       "      <td>12018271301</td>\n",
       "      <td>针织</td>\n",
       "      <td>针织</td>\n",
       "      <td>春2</td>\n",
       "      <td>9000</td>\n",
       "      <td>ODM</td>\n",
       "      <td>...</td>\n",
       "      <td>27</td>\n",
       "      <td>1</td>\n",
       "      <td>179</td>\n",
       "      <td>157341</td>\n",
       "      <td>18S1S2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>60</td>\n",
       "      <td>718</td>\n",
       "      <td>49</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>366 rows × 32 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     ﻿订单类别  订单日期 NB5日期   系统           款号 采购组 采购组2   批次    色号    模式 ...  中类  \\\n",
       "0                                                                  ...       \n",
       "1       电商  7/27   8/3  2系统  19018000201  针织   针织  第一批   144   FOB ...   0   \n",
       "2       电商  7/27   8/3  2系统  19018000204  针织   针织  第一批   134   FOB ...   0   \n",
       "39      电商  7/27   8/3  2系统  19018010201  针织   针织  第三批  1100   FOB ...   1   \n",
       "40      电商  7/27   8/3  2系统  19018010201  针织   针织  第三批  3410   FOB ...   1   \n",
       "41      电商  7/27   8/3  2系统  19018010201  针织   针织  第三批  8000   FOB ...   1   \n",
       "42      电商  7/27   8/3  2系统  19018010201  针织   针织  第三批  1100   FOB ...   1   \n",
       "43      电商  7/27   8/3  2系统  19018010201  针织   针织  第三批  3410   FOB ...   1   \n",
       "44      电商  7/27   8/3  2系统  19018010201  针织   针织  第三批  8000   FOB ...   1   \n",
       "45      电商  7/27   8/3  2系统  19018010201  针织   针织  第三批  1100   FOB ...   1   \n",
       "46      电商  7/27   8/3  2系统  19018010201  针织   针织  第三批  3410   FOB ...   1   \n",
       "47      电商  7/27   8/3  2系统  19018010201  针织   针织  第三批  8000   FOB ...   1   \n",
       "48      电商  7/27   8/3  2系统  19018010202  针织   针织  第三批  1100   FOB ...   1   \n",
       "49      电商  7/27   8/3  2系统  19018010202  针织   针织  第三批  8000   FOB ...   1   \n",
       "50      电商  7/27   8/3  2系统  19018010202  针织   针织  第三批  9000   FOB ...   1   \n",
       "51      电商  7/27   8/3  2系统  19018010202  针织   针织  第三批  1100   FOB ...   1   \n",
       "52      电商  7/27   8/3  2系统  19018010202  针织   针织  第三批  8000   FOB ...   1   \n",
       "53      电商  7/27   8/3  2系统  19018010202  针织   针织  第三批  9000   FOB ...   1   \n",
       "54      电商  7/27   8/3  2系统  19018010202  针织   针织  第三批  1100   FOB ...   1   \n",
       "55      电商  7/27   8/3  2系统  19018010202  针织   针织  第三批  8000   FOB ...   1   \n",
       "56      电商  7/27   8/3  2系统  19018010202  针织   针织  第三批  9000   FOB ...   1   \n",
       "57      电商  7/27   8/3  2系统  19018010203  针织   针织  第二批  1100   FOB ...   1   \n",
       "58      电商  7/27   8/3  2系统  19018010203  针织   针织  第二批  6600   FOB ...   1   \n",
       "59      电商  7/27   8/3  2系统  19018010203  针织   针织  第二批  9000   FOB ...   1   \n",
       "60      电商  7/27   8/3  2系统  19018010203  针织   针织  第二批  1100   FOB ...   1   \n",
       "61      电商  7/27   8/3  2系统  19018010203  针织   针织  第二批  6600   FOB ...   1   \n",
       "62      电商  7/27   8/3  2系统  19018010203  针织   针织  第二批  9000   FOB ...   1   \n",
       "63      电商  7/27   8/3  2系统  19018010203  针织   针织  第二批  1100   FOB ...   1   \n",
       "64      电商  7/27   8/3  2系统  19018010203  针织   针织  第二批  6600   FOB ...   1   \n",
       "65      电商  7/27   8/3  2系统  19018010203  针织   针织  第二批  9000   FOB ...   1   \n",
       "66      电商  7/27   8/3  2系统  19018010203  针织   针织  第二批  1100   FOB ...   1   \n",
       "...    ...   ...   ...  ...          ...  ..  ...  ...   ...   ... ...  ..   \n",
       "2653   订货会  8/15  8/15  2系统  12028001017  针织   针织   初夏   291   FOB ...   0   \n",
       "2658   订货会  8/15  8/15  2系统  12028001020  针织   针织   初夏  1000   ODM ...   0   \n",
       "2659   订货会  8/15  8/15  2系统  12028001020  针织   针织   初夏  1000   ODM ...   0   \n",
       "2660   订货会  8/15  8/15  2系统  12028001020  针织   针织   初夏  9000   ODM ...   0   \n",
       "2661   订货会  8/15  8/15  2系统  12028001020  针织   针织   初夏  9000   ODM ...   0   \n",
       "2790   订货会  8/15  8/15  1系统  12028160020  针织   针织   初夏  6129   FOB ...  16   \n",
       "2791   订货会  8/15  8/15  1系统  12028160020  针织   针织   初夏  6129   FOB ...  16   \n",
       "2792   订货会  8/15  8/15  1系统  12028160020  针织   针织   初夏  8640   FOB ...  16   \n",
       "2793   订货会  8/15  8/15  1系统  12028160020  针织   针织   初夏  8640   FOB ...  16   \n",
       "2794   订货会  8/15  8/15  2系统  12028160022  针织   针织   初夏  1100  CFOB ...  16   \n",
       "2795   订货会  8/15  8/15  2系统  12028160022  针织   针织   初夏  1100  CFOB ...  16   \n",
       "2796   订货会  8/15  8/15  2系统  12028160022  针织   针织   初夏  1100  CFOB ...  16   \n",
       "2797   订货会  8/15  8/15  2系统  12028160022  针织   针织   初夏  6606  CFOB ...  16   \n",
       "2798   订货会  8/15  8/15  2系统  12028160022  针织   针织   初夏  6606  CFOB ...  16   \n",
       "2799   订货会  8/15  8/15  2系统  12028160022  针织   针织   初夏  6606  CFOB ...  16   \n",
       "2800   订货会  8/15  8/15  2系统  12028160022  针织   针织   初夏  8640  CFOB ...  16   \n",
       "2801   订货会  8/15  8/15  2系统  12028160022  针织   针织   初夏  8640  CFOB ...  16   \n",
       "2802   订货会  8/15  8/15  2系统  12028160022  针织   针织   初夏  8640  CFOB ...  16   \n",
       "2819   订货会  8/15  8/15  2系统  12028161009  针织   针织   初夏  1100   ODM ...  16   \n",
       "2820   订货会  8/15  8/15  2系统  12028161009  针织   针织   初夏  1100   ODM ...  16   \n",
       "2821   订货会  8/15  8/15  2系统  12028161009  针织   针织   初夏  4500   ODM ...  16   \n",
       "2822   订货会  8/15  8/15  2系统  12028161009  针织   针织   初夏  4500   ODM ...  16   \n",
       "2823   订货会  8/15  8/15  2系统  12028161009  针织   针织   初夏  9000   ODM ...  16   \n",
       "2824   订货会  8/15  8/15  2系统  12028161009  针织   针织   初夏  9000   ODM ...  16   \n",
       "2829   订货会  8/15  8/15  2系统  12028260264  针织   针织   初夏  9000  CFOB ...  26   \n",
       "2830   订货会  8/15  8/15  2系统  12028260264  针织   针织   初夏  9000  CFOB ...  26   \n",
       "4994   订货会   8/8  8/28  2系统  12018271301  针织   针织   春2    12   ODM ...  27   \n",
       "4995   订货会   8/8  8/28  2系统  12018271301  针织   针织   春2    12   ODM ...  27   \n",
       "4996   订货会   8/8  8/28  2系统  12018271301  针织   针织   春2  9000   ODM ...  27   \n",
       "4997   订货会   8/8  8/28  2系统  12018271301  针织   针织   春2  9000   ODM ...  27   \n",
       "\n",
       "      性别  吊牌价      市值      季节  计划员 件数/箱    箱数 出货周数  12  \n",
       "0                                                       \n",
       "1      0  159  159000  18S1S2  朱晓红  140     7   48  15  \n",
       "2      0   99   99000  18S1S2  朱晓红  140     7   48  15  \n",
       "39     0   99  105534  18S1S2  朱晓红  100    11   50  16  \n",
       "40     0   99   37323  18S1S2  朱晓红  100     4   50  16  \n",
       "41     0   99   82467  18S1S2  朱晓红  100     8   50  16  \n",
       "42     0   99  113454  18S1S2  朱晓红  100    11   50  16  \n",
       "43     0   99   33561  18S1S2  朱晓红  100     3   50  16  \n",
       "44     0   99   76527  18S1S2  朱晓红  100     8   50  16  \n",
       "45     0   99  454212  18S1S2  朱晓红  100    46   50  16  \n",
       "46     0   99  146916  18S1S2  朱晓红  100    15   50  16  \n",
       "47     0   99  306306  18S1S2  朱晓红  100    31   50  16  \n",
       "48     0   89   90246  18S1S2  朱晓红  100    10   50  17  \n",
       "49     0   89   95586  18S1S2  朱晓红  100    11   50  17  \n",
       "50     0   89   74137  18S1S2  朱晓红  100     8   50  17  \n",
       "51     0   89   92293  18S1S2  朱晓红  100    10   50  17  \n",
       "52     0   89  103685  18S1S2  朱晓红  100    12   50  17  \n",
       "53     0   89   84817  18S1S2  朱晓红  100    10   50  17  \n",
       "54     0   89  369261  18S1S2  朱晓红  100    41   50  17  \n",
       "55     0   89  414829  18S1S2  朱晓红  100    47   50  17  \n",
       "56     0   89  339446  18S1S2  朱晓红  100    38   50  17  \n",
       "57     0  119  153867  18S1S2  朱晓红  100    13   49  17  \n",
       "58     0  119  118643  18S1S2  朱晓红  100    10   49  17  \n",
       "59     0  119  153867  18S1S2  朱晓红  100    13   49  17  \n",
       "60     0  119  209440  18S1S2  朱晓红  100    18   51   3  \n",
       "61     0  119  121499  18S1S2  朱晓红  100    10   51   3  \n",
       "62     0  119  173740  18S1S2  朱晓红  100    15   51   3  \n",
       "63     0  119  447202  18S1S2  朱晓红  100    38   49  17  \n",
       "64     0  119  244426  18S1S2  朱晓红  100    21   49  17  \n",
       "65     0  119  357833  18S1S2  朱晓红  100    30   49  17  \n",
       "66     0  119  391391  18S1S2  朱晓红  100    33   51   3  \n",
       "...   ..  ...     ...     ...  ...  ...   ...  ...  ..  \n",
       "2653   1   99   48510  18S1S2  朱晓红  140   308   50  31  \n",
       "2658   1  119   53074  18S1S2  朱晓红  140   308   50  31  \n",
       "2659   1  119   82110  18S1S2  朱晓红  140   308   50  31  \n",
       "2660   1  119   51527  18S1S2  朱晓红  140   308   50  31  \n",
       "2661   1  119   55216  18S1S2  朱晓红  140   308   50  31  \n",
       "2790   0  159  105258  18S1S2  朱晓红   40  1077   50  31  \n",
       "2791   0  159   90948  18S1S2  朱晓红   40  1077   50  31  \n",
       "2792   0  159   92061  18S1S2  朱晓红   40  1077   50  31  \n",
       "2793   0  159   65349  18S1S2  朱晓红   40  1077   50  31  \n",
       "2794   0  119  408170  18S1S2  朱晓红   40  1077   51  32  \n",
       "2795   0  119  661045  18S1S2  朱晓红   40  1077   52  31  \n",
       "2796   0  119  333200  18S1S2  朱晓红   40  1077   50  31  \n",
       "2797   0  119  427091  18S1S2  朱晓红   40  1077   51  32  \n",
       "2798   0  119  685916  18S1S2  朱晓红   40  1077   52  31  \n",
       "2799   0  119  364140  18S1S2  朱晓红   40  1077   50  31  \n",
       "2800   0  119   20468  18S1S2  朱晓红   40  1077   51  32  \n",
       "2801   0  119   54026  18S1S2  朱晓红   40  1077   52  31  \n",
       "2802   0  119   20706  18S1S2  朱晓红   40  1077   50  31  \n",
       "2819   1  139  211836  18S1S2  朱晓红   40  1077   50  31  \n",
       "2820   1  139   14595  18S1S2  朱晓红   40  1077   50  31  \n",
       "2821   1  139  173611  18S1S2  朱晓红   40  1077   50  31  \n",
       "2822   1  139   15707  18S1S2  朱晓红   40  1077   50  31  \n",
       "2823   1  139  223234  18S1S2  朱晓红   40  1077   50  31  \n",
       "2824   1  139   23630  18S1S2  朱晓红   40  1077   50  31  \n",
       "2829   0  199  193229  18S1S2  朱晓红   70   615   50  31  \n",
       "2830   0  199   53929  18S1S2  朱晓红   70   615   50  31  \n",
       "4994   1  179   35621  18S1S2  NaN   60   718   49  15  \n",
       "4995   1  179  107579  18S1S2  NaN   60   718   49  15  \n",
       "4996   1  179  249526  18S1S2  NaN   60   718   49  15  \n",
       "4997   1  179  157341  18S1S2  NaN   60   718   49  15  \n",
       "\n",
       "[366 rows x 32 columns]"
      ]
     },
     "execution_count": 113,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns = column[1:]\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 101,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "ename": "TypeError",
     "evalue": "'tuple' object is not callable",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mTypeError\u001b[0m                                 Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-101-5c9df9afc8b0>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[0;32m----> 1\u001b[0;31m \u001b[0mdf\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mrename\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mcolumns\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mtuple\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mcolumn\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0minplace\u001b[0m\u001b[1;33m=\u001b[0m\u001b[1;32mTrue\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[0;32mD:\\Anaconda\\lib\\site-packages\\pandas\\core\\frame.py\u001b[0m in \u001b[0;36mrename\u001b[0;34m(self, index, columns, **kwargs)\u001b[0m\n\u001b[1;32m   2832\u001b[0m     \u001b[1;32mdef\u001b[0m \u001b[0mrename\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mindex\u001b[0m\u001b[1;33m=\u001b[0m\u001b[1;32mNone\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mcolumns\u001b[0m\u001b[1;33m=\u001b[0m\u001b[1;32mNone\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;33m**\u001b[0m\u001b[0mkwargs\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m   2833\u001b[0m         return super(DataFrame, self).rename(index=index, columns=columns,\n\u001b[0;32m-> 2834\u001b[0;31m                                              **kwargs)\n\u001b[0m\u001b[1;32m   2835\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m   2836\u001b[0m     \u001b[1;33m@\u001b[0m\u001b[0mAppender\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0m_shared_docs\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;34m'fillna'\u001b[0m\u001b[1;33m]\u001b[0m \u001b[1;33m%\u001b[0m \u001b[0m_shared_doc_kwargs\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[0;32mD:\\Anaconda\\lib\\site-packages\\pandas\\core\\generic.py\u001b[0m in \u001b[0;36mrename\u001b[0;34m(self, *args, **kwargs)\u001b[0m\n\u001b[1;32m    678\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m    679\u001b[0m             \u001b[0mbaxis\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_get_block_manager_axis\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0maxis\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m--> 680\u001b[0;31m             \u001b[0mresult\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_data\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mresult\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_data\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mrename_axis\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mf\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0maxis\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mbaxis\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mcopy\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mcopy\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    681\u001b[0m             \u001b[0mresult\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_clear_item_cache\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m    682\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[0;32mD:\\Anaconda\\lib\\site-packages\\pandas\\core\\internals.py\u001b[0m in \u001b[0;36mrename_axis\u001b[0;34m(self, mapper, axis, copy)\u001b[0m\n\u001b[1;32m   2816\u001b[0m         \"\"\"\n\u001b[1;32m   2817\u001b[0m         \u001b[0mobj\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mcopy\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mdeep\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mcopy\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m-> 2818\u001b[0;31m         \u001b[0mobj\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mset_axis\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0maxis\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0m_transform_index\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0maxes\u001b[0m\u001b[1;33m[\u001b[0m\u001b[0maxis\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mmapper\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   2819\u001b[0m         \u001b[1;32mreturn\u001b[0m \u001b[0mobj\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m   2820\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[0;32mD:\\Anaconda\\lib\\site-packages\\pandas\\core\\internals.py\u001b[0m in \u001b[0;36m_transform_index\u001b[0;34m(index, func)\u001b[0m\n\u001b[1;32m   4746\u001b[0m         \u001b[1;32mreturn\u001b[0m \u001b[0mMultiIndex\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mfrom_tuples\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mitems\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mnames\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mindex\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mnames\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m   4747\u001b[0m     \u001b[1;32melse\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m-> 4748\u001b[0;31m         \u001b[0mitems\u001b[0m \u001b[1;33m=\u001b[0m \u001b[1;33m[\u001b[0m\u001b[0mfunc\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mx\u001b[0m\u001b[1;33m)\u001b[0m \u001b[1;32mfor\u001b[0m \u001b[0mx\u001b[0m \u001b[1;32min\u001b[0m \u001b[0mindex\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   4749\u001b[0m         \u001b[1;32mreturn\u001b[0m \u001b[0mIndex\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mitems\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mname\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mindex\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mname\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m   4750\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[0;32mD:\\Anaconda\\lib\\site-packages\\pandas\\core\\internals.py\u001b[0m in \u001b[0;36m<listcomp>\u001b[0;34m(.0)\u001b[0m\n\u001b[1;32m   4746\u001b[0m         \u001b[1;32mreturn\u001b[0m \u001b[0mMultiIndex\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mfrom_tuples\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mitems\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mnames\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mindex\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mnames\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m   4747\u001b[0m     \u001b[1;32melse\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m-> 4748\u001b[0;31m         \u001b[0mitems\u001b[0m \u001b[1;33m=\u001b[0m \u001b[1;33m[\u001b[0m\u001b[0mfunc\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mx\u001b[0m\u001b[1;33m)\u001b[0m \u001b[1;32mfor\u001b[0m \u001b[0mx\u001b[0m \u001b[1;32min\u001b[0m \u001b[0mindex\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   4749\u001b[0m         \u001b[1;32mreturn\u001b[0m \u001b[0mIndex\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mitems\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mname\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mindex\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mname\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m   4750\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[0;31mTypeError\u001b[0m: 'tuple' object is not callable"
     ]
    }
   ],
   "source": [
    "df.rename(columns=tuple(column), inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 83,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[2, 4, 4, 6]"
      ]
     },
     "execution_count": 83,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "a = [i*2 for i in lst ]\n",
    "a"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 85,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 96,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([ 4,  8,  8, 12])"
      ]
     },
     "execution_count": 96,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "np.array(a)*2"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
